package com.hrm.mapper;

import com.github.pagehelper.Page;
import com.hrm.pojo.Job;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.sql.SQLException;
import java.util.List;

@Repository
public interface JobMapper {
    int deleteByPrimaryKey(Integer id);
    int deleteJobAndRelatedEmployees(@Param("ids") List<Integer> ids);
    int deleteByPrimaryKeys(@Param("ids") List<Integer> ids);


    int insert(Job record);

    int insertSelective(Job record);

    Job selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(Job record);

    int updateByPrimaryKey(Job record);

    Page<Job> selectLikeName(Job job)throws SQLException;
    List<Job> selectJobList()throws SQLException;

}